<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib  prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib  prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<%@ taglib  prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ taglib prefix="redis" uri="http://www.shopjsp.com/redisTag/functions" %>
<%@ taglib prefix="shiro" uri="http://shiro.apache.org/tags" %>
<c:set var="basePath" value="${redis:getSysConfig('base_path_back')}"/>
<c:set var="uploadPath" value="${redis:getSysConfig('uploadFileVisitRoot')}"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<title>订单统计信息</title>
	<jsp:include page="../../util/import.jsp"/>
	<script type="text/javascript">
        $(function(){
            var $tt= $("#tt").bootstrapTable({
                url: '${basePath}/back/mallSummary/ListCollectiveOrder.sjson',         	/**请求后台的URL（*）**/
                method: 'post',                       	/**请求方式（*）**/
                contentType: "application/x-www-form-urlencoded",
                dataType: 'json',
                toolbar: '#toolbar',               	    /**工具按钮用哪个容器**/
                striped: true,                      	/**是否显示行间隔色**/
                cache: false,                       	/**是否使用缓存，默认为true，所以一般情况下需要设置一下这个属性（*）**/
                pagination: true,                   	/**是否显示分页（*）**/
                sortable: false,                    	/**是否启用排序**/
                sortOrder: 'asc',                   	/**排序方式**/
                queryParamsType: '',
                sidePagination: 'server',           	/**分页方式：client客户端分页，server服务端分页（*）**/
                pageNumber: 1,
                pageSize:10,							/**初始化加载第一页，默认第一页**/
                pageList: [5,10, 25, 50],        	    /**可供选择的每页的行数（*）**/
                search: false,                       	/**是否显示表格搜索，此搜索是客户端搜索，不会进服务端，所以，个人感觉意义不大**/
                strictSearch: true,
                showColumns: true,                  	/**是否显示所有的列**/
                showRefresh: true,                  	/**是否显示刷新按钮**/
                minimumCountColumns: 2,             	/**最少允许的列数**/
                clickToSelect: true,                	/**是否启用点击选中行**/
                uniqueId: 'ordersId',                    /**每一行的唯一标识，一般为主键列**/
                singleSelect  : true,                   /** 单选checkbox**/
                showToggle:false,                    	/**是否显示详细视图和列表视图的切换按钮**/
                cardView: false,                    	/**是否显示详细视图**/
                detailView: false,                  	/**是否显示父子表**/
                columns: [
                    {checkbox: true},
                    {field: 'Number', title: '编号',align: 'center',valign: 'middle',width:'50px',
                        formatter: function (value, row, index) {
                            var page = $tt.bootstrapTable("getPage");
                            return page.pageSize * (page.pageNumber - 1) + index + 1;
                        }
                    },
                    {field: 'ordersNo',title: '订单编号',align: 'center',valign: 'middle'},
                    {field: 'shopName',title: '商户店铺名称',align: 'center',valign: 'middle'},
                    {field: 'shopInfoType',title: '店铺类型',align: 'center',valign: 'middle',
                        formatter:function(value,row,index){
                            if(value=="1"){ return "<font class='color_001'>自营店铺</font>";}
                            if(value=="2"){ return "<font class='color_002'>入驻店铺</font>";}
                        }
                    },
                    {field: 'loginName',title: '买家会员名称',align: 'center',valign: 'middle'},
                    {field: 'consignee',title: '收货人名称',align: 'center',valign: 'middle'},
                    {field: 'totalAmount',title: '商品总金额(元)',align: 'center',valign: 'middle'},
                    {field: 'discount',title: '折扣',align: 'center',valign: 'middle',
                        formatter:function(value,row,index){
                            var info = "";
                            if(value == null){
                                info = "无折扣";
                            }else{
                                info = value;
                            }
                            return info;
                        }
                    },
                    {field: 'userCoin',title: '使用积分',align: 'center',valign: 'middle'},
                    {field: 'changeAmount',title: '积分抵扣金额(元)',align: 'center',valign: 'middle'},
                    {field: 'orderCouponAmount',title: '优惠券抵扣(元)',align: 'center',valign: 'middle'},
                    {field: 'freight',title: '运费(元)',align: 'center',valign: 'middle'},
                    {field: 'taxRate',title: '税率(%)',align: 'center',valign: 'middle'},
                    {field: 'taxRateAmount',title: '税金(元)',align: 'center',valign: 'middle'},
                    {field: 'finalAmount',title: '订单应付金额(元)',align: 'center',valign: 'middle'},
                    {field: 'virtualCoinNumber',title: '赠送积分',align: 'center',valign: 'middle'},
                    {field: 'createTime',title: '订单生成时间',align: 'center',valign: 'middle'},
                    {field: 'payTime',title: '付款时间',align: 'center',valign: 'middle'},
                    {field: 'distributionTime',title: '配货时间',align: 'center',valign: 'middle'},
                    {field: 'deliversTime',title: '发货时间',align: 'center',valign: 'middle'},
                    {field: 'receivesTime',title: '收货时间',align: 'center',valign: 'middle'}
                ],
                queryParams: function (params) {
                    /**特别说明，返回的参数的值为空，则当前参数不会发送到服务器端,这种指定请求参数的方式和datatables控价类似**/
                    params.shopName = $("#q_shopName").val();
                    params.ordersState = $("#q_ordersState").val();
                    params.shopInfoType = $("#q_shopInfoType").val();
                    params.beginTime = $("#q_createTime_start").val();
                    params.endTime = $("#q_createTime_end").val();
                    params.currentPage = params.pageNumber;
                    return params;
                }
            });
        });

        /**
		 * 导出报表
         */
		<shiro:hasPermission name="back_gotoCollectiveOrderPage_export">
        function exportCollectiveOrderExcel() {
            window.location.href="${basePath}/back/mallSummary/exportCollectiveOrder.inhtm?shopName="+$("#q_shopName").val()+"&ordersState="+$("#q_ordersState").val()+"&shopInfoType="+$("#q_shopInfoType").val()+"&beginTime="+$("#q_createTime_start").val()+"&endTime="+$("#q_createTime_end").val();
        }
		</shiro:hasPermission>
	</script>
</head>

<body>
<div class="panel-body" id="customer-main-panel">
	<!-- 查询条件 -->
	<div class="panel panel-default">
		<div class="panel-heading">订单统计信息查询</div>
		<div class="panel-body">
			<form id="qform" class="form-horizontal">
				<div class="form-group" style="margin-top:15px">
					<div class="col-sm-3" >
						<div class="input-group input-group-sm">
							<span class="input-group-addon">店铺名称</span>
							<input type="text" class="form-control" id="q_shopName" name="shopName" placeholder="请输入店铺名称"/>
						</div>
					</div>
					<div class="col-sm-3" style="width: 200px;">
						<div class="input-group input-group-sm">
							<span class="input-group-addon">订单状态</span>
							<select id="q_ordersState" class="form-control">
								<option value="">--全部--</option>
								<option value="1">生成订单(未付款)</option>
								<option value="2">生成订单(已付款)</option>
								<option value="9">已付款(不含已取消)</option>
								<option value="3">配货</option>
								<option value="4">发货</option>
								<option value="5">已完成</option>
								<option value="6">取消订单</option>
							</select>
						</div>
					</div>
					<div class="col-sm-3" style="width: 200px;">
						<div class="input-group input-group-sm">
							<span class="input-group-addon">店铺类型</span>
							<select id="q_shopInfoType" class="form-control">
								<option value="">--请选择--</option>
								<option value="1">自营店铺</option>
								<option value="2">入驻店铺</option>
							</select>
						</div>
					</div>
					<div class="col-sm-2" style="width: 340px;">
						<div class="input-group input-group-sm ">
							<span class="input-group-addon">交易开始时间</span>
							<div class="input-group date form_datetime" data-link-field="dtp_input1">
								<input id="q_createTime_start" name="q_createTime_start" style="height: 30px; border: 1px solid #c6c6c6;border-right:none;padding-left:10px; " size="17.5" type="text" value=""  placeholder="请选择交易开始时间" readonly>
								<span class="input-group-addon"><span class="glyphicon glyphicon-remove"></span></span>
								<span class="input-group-addon"><span class="glyphicon glyphicon-th"></span></span>
							</div>
							<script type="text/javascript">
                                $('.form_datetime').datetimepicker({format: "yyyy-MM-dd",language:'zh-CN',weekStart:1, todayBtn:1,autoclose: 1,todayHighlight: 1,startView: 2, minView: 2, forceParse: 0});
							</script>
						</div>
					</div>
					<div class="col-sm-2" style="width: 340px;">
						<div class="input-group input-group-sm ">
							<span class="input-group-addon">交易结束时间</span>
							<div class="input-group date form_datetime" data-link-field="dtp_input1">
								<input id="q_createTime_end" name="q_createTime_end" style="height: 30px; border: 1px solid #c6c6c6;border-right:none;padding-left:10px; " size="17.5" type="text" value=""  placeholder="请选择交易结束时间" readonly>
								<span class="input-group-addon"><span class="glyphicon glyphicon-remove"></span></span>
								<span class="input-group-addon"><span class="glyphicon glyphicon-th"></span></span>
							</div>
							<script type="text/javascript">
                                $('.form_datetime').datetimepicker({format: "yyyy-MM-dd",language:'zh-CN',weekStart:1, todayBtn:1,autoclose: 1,todayHighlight: 1,startView: 2, minView: 2, forceParse: 0});
							</script>
						</div>
					</div>
					<div class="col-sm-2">
						<button type="button" id="btn_query" class="btn btn-primary">查询</button>&nbsp;&nbsp;
						<button type="reset" class="btn btn-success" id="resetBtn">重置</button>
					</div>
				</div>
			</form>
		</div>
	</div>

	<!-- 工具栏 -->
	<div id="toolbar" class="btn-group">
		<shiro:hasPermission name="back_gotoCollectiveOrderPage_export">
			<button id="btn_export" type="button" class="btn btn-default" onclick="exportCollectiveOrderExcel()">
				<span class="glyphicon glyphicon-export" aria-hidden="true"></span>&nbsp;导出报表
			</button>
		</shiro:hasPermission>

		<shiro:hasPermission name="back_gotoCollectiveOrderPage_chartDisplay">
			<button id="btn_signal" type="button" class="btn btn-default" onclick="">
				<span class="glyphicon glyphicon-signal" aria-hidden="true"></span>&nbsp;图表展示
			</button>
		</shiro:hasPermission>
	</div>
	<!-- 渲染的table -->
	<table id="tt"></table>
</div>
</body>
</html>
